using System;
using System.Data;
using SubSonic;

namespace Medianamik.UI.Web.Membership.Data{
    public partial class SPs{
        /// <summary>
        /// Creates an object wrapper for the medianamik_GetUsersByGroups Procedure
        /// </summary>
        public static StoredProcedure MedianamikGetUsersByGroups(string Groups, int? PageSize, int? PageIndex, string keywords, bool? IsActive)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("medianamik_GetUsersByGroups", DataService.GetInstance("MedianamikProvider"), "dbo");

            sp.Command.AddParameter("@Groups", Groups, DbType.AnsiString, null, null);

            sp.Command.AddParameter("@PageSize", PageSize, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@PageIndex", PageIndex, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@keywords", keywords, DbType.AnsiString, null, null);

            sp.Command.AddParameter("@IsActive", IsActive, DbType.Boolean, null, null);

            return sp;
        }

        /// <summary>
        /// Creates an object wrapper for the medianamik_GetUsersByGroupsCount Procedure
        /// </summary>
        public static StoredProcedure MedianamikGetUsersByGroupsCount(string Groups, string keywords, bool? IsActive)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("medianamik_GetUsersByGroupsCount", DataService.GetInstance("MedianamikProvider"), "dbo");

            sp.Command.AddParameter("@Groups", Groups, DbType.AnsiString, null, null);

            sp.Command.AddParameter("@keywords", keywords, DbType.AnsiString, null, null);

            sp.Command.AddParameter("@IsActive", IsActive, DbType.Boolean, null, null);

            return sp;
        }
    }
}
